package com.example.othree.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.example.othree.entity.Aot40HistoryDayDataHsxt;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.othree.entity.WeatherStationInfo;
import org.apache.ibatis.annotations.Param;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author zogran
 * @since 2024-11-12
 */
public interface Aot40HistoryDayDataHsxtMapper extends BaseMapper<Aot40HistoryDayDataHsxt> {
    IPage PageList(IPage<Aot40HistoryDayDataHsxt> page, @Param(Constants.WRAPPER) Wrapper wrapper);

    List<Aot40HistoryDayDataHsxt> spaceData(String city,
                                            String element,
                                            String year,
                                            String crop,
                                            String startDate, String endDate);

    ArrayList<Aot40HistoryDayDataHsxt> spaceDataForDay(String city,
                                                       String district,
                                                       String element,
                                                       String year,
                                                       String crop,
                                                       String startDate, String endDate);

    ArrayList<WeatherStationInfo> lonLatInfo();

    List<Map<String, Object>> countyToLonLat(String city);
}
